Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 119143 |
| Missing cells | 20754 |
| Missing cells (%) | 0.6% |
| Duplicate rows | 7779 |
| Duplicate rows (%) | 6.5% |
| Total size in memory | 30.4 MiB |
| Average record size in memory | 267.5 B |
Variable types
| Categorical | 16 |
|---|---|
| Numeric | 12 |
| Dataset has 7779 (6.5%) duplicate rows | Duplicates |
order_purchase_timestamp has a high cardinality: 98875 distinct values | High cardinality |
order_approved_at has a high cardinality: 90733 distinct values | High cardinality |
order_delivered_carrier_date has a high cardinality: 81018 distinct values | High cardinality |
order_delivered_customer_date has a high cardinality: 95664 distinct values | High cardinality |
order_estimated_delivery_date has a high cardinality: 459 distinct values | High cardinality |
review_creation_date has a high cardinality: 636 distinct values | High cardinality |
review_answer_timestamp has a high cardinality: 98248 distinct values | High cardinality |
shipping_limit_date has a high cardinality: 93318 distinct values | High cardinality |
customer_city has a high cardinality: 4119 distinct values | High cardinality |
product_category_name_english has a high cardinality: 72 distinct values | High cardinality |
seller_city has a high cardinality: 611 distinct values | High cardinality |
payment_value is highly overall correlated with price | High correlation |
price is highly overall correlated with payment_value and 1 other fields | High correlation |
product_weight_g is highly overall correlated with price and 3 other fields | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_width_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
order_status is highly imbalanced (91.6%) | Imbalance |
payment_type is highly imbalanced (52.6%) | Imbalance |
seller_state is highly imbalanced (63.3%) | Imbalance |
order_delivered_carrier_date has 2086 (1.8%) missing values | Missing |
order_delivered_customer_date has 3421 (2.9%) missing values | Missing |
order_purchase_timestamp is uniformly distributed | Uniform |
order_approved_at is uniformly distributed | Uniform |
order_delivered_customer_date is uniformly distributed | Uniform |
review_answer_timestamp is uniformly distributed | Uniform |
shipping_limit_date is uniformly distributed | Uniform |
length_comment_title has 104159 (87.4%) zeros | Zeros |
length_comment_message has 67932 (57.0%) zeros | Zeros |
product_description_lenght has 1709 (1.4%) zeros | Zeros |
product_photos_qty has 1709 (1.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-08 13:42:44.376976 |
|---|---|
| Analysis finished | 2023-02-08 13:43:28.016804 |
| Duration | 43.64 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
order_status
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| delivered | |
|---|---|
| shipped | 1256 |
| canceled | 750 |
| unavailable | 652 |
| invoiced | 378 |
| Other values (3) | 384 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9834401 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1070314 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 115723 | |
| shipped | 1256 | 1.1% |
| canceled | 750 | 0.6% |
| unavailable | 652 | 0.5% |
| invoiced | 378 | 0.3% |
| processing | 376 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 115723 | |
| shipped | 1256 | 1.1% |
| canceled | 750 | 0.6% |
| unavailable | 652 | 0.5% |
| invoiced | 378 | 0.3% |
| processing | 376 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1070314 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1070314 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1070314 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
order_purchase_timestamp
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 98875 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| 2017-08-08 20:26:31 | 63 |
|---|---|
| 2017-09-23 14:56:45 | 38 |
| 2017-04-20 12:45:34 | 29 |
| 2017-06-07 12:05:10 | 26 |
| 2018-05-12 12:28:58 | 24 |
| Other values (98870) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2263717 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85645 ? |
|---|---|
| Unique (%) | 71.9% |
Sample
| 1st row | 2017-10-02 10:56:33 |
|---|---|
| 2nd row | 2017-10-02 10:56:33 |
| 3rd row | 2017-10-02 10:56:33 |
| 4th row | 2017-08-15 18:29:31 |
| 5th row | 2017-08-02 18:24:47 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:26:31 | 63 | 0.1% |
| 2017-09-23 14:56:45 | 38 | < 0.1% |
| 2017-04-20 12:45:34 | 29 | < 0.1% |
| 2017-06-07 12:05:10 | 26 | < 0.1% |
| 2018-05-12 12:28:58 | 24 | < 0.1% |
| 2018-02-14 16:34:27 | 24 | < 0.1% |
| 2017-07-07 14:55:43 | 24 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2017-11-25 13:54:39 | 24 | < 0.1% |
| 2017-12-08 12:00:04 | 22 | < 0.1% |
| Other values (98865) | 118845 |
Length
| Value | Count | Frequency (%) |
| 2017-11-24 | 1435 | 0.6% |
| 2017-11-25 | 640 | 0.3% |
| 2017-11-27 | 508 | 0.2% |
| 2017-11-26 | 485 | 0.2% |
| 2017-11-28 | 453 | 0.2% |
| 2018-08-06 | 445 | 0.2% |
| 2018-08-07 | 444 | 0.2% |
| 2018-05-15 | 441 | 0.2% |
| 2018-05-07 | 430 | 0.2% |
| 2018-05-14 | 425 | 0.2% |
| Other values (51442) | 232580 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 368631 | |
| 0 | 366708 | |
| 2 | 290748 | |
| - | 238286 | |
| : | 238286 | |
| 8 | 123332 | 5.4% |
| 119143 | 5.3% | |
| 7 | 111011 | 4.9% |
| 3 | 105264 | 4.7% |
| 5 | 96250 | 4.3% |
| Other values (3) | 206058 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1668002 | |
| Dash Punctuation | 238286 | 10.5% |
| Other Punctuation | 238286 | 10.5% |
| Space Separator | 119143 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 368631 | |
| 0 | 366708 | |
| 2 | 290748 | |
| 8 | 123332 | 7.4% |
| 7 | 111011 | 6.7% |
| 3 | 105264 | 6.3% |
| 5 | 96250 | 5.8% |
| 4 | 96104 | 5.8% |
| 6 | 56686 | 3.4% |
| 9 | 53268 | 3.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 238286 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 238286 |
Space Separator
| Value | Count | Frequency (%) |
| 119143 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2263717 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 368631 | |
| 0 | 366708 | |
| 2 | 290748 | |
| - | 238286 | |
| : | 238286 | |
| 8 | 123332 | 5.4% |
| 119143 | 5.3% | |
| 7 | 111011 | 4.9% |
| 3 | 105264 | 4.7% |
| 5 | 96250 | 4.3% |
| Other values (3) | 206058 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2263717 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 368631 | |
| 0 | 366708 | |
| 2 | 290748 | |
| - | 238286 | |
| : | 238286 | |
| 8 | 123332 | 5.4% |
| 119143 | 5.3% | |
| 7 | 111011 | 4.9% |
| 3 | 105264 | 4.7% |
| 5 | 96250 | 4.3% |
| Other values (3) | 206058 |
order_approved_at
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 90733 |
|---|---|
| Distinct (%) | 76.3% |
| Missing | 177 |
| Missing (%) | 0.1% |
| Memory size | 1.8 MiB |
| 2017-08-08 20:43:31 | 63 |
|---|---|
| 2017-09-25 17:44:41 | 38 |
| 2017-04-22 09:10:13 | 29 |
| 2017-06-09 16:15:08 | 26 |
| 2017-03-09 23:39:26 | 24 |
| Other values (90728) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2260354 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 72654 ? |
|---|---|
| Unique (%) | 61.1% |
Sample
| 1st row | 2017-10-02 11:07:15 |
|---|---|
| 2nd row | 2017-10-02 11:07:15 |
| 3rd row | 2017-10-02 11:07:15 |
| 4th row | 2017-08-15 20:05:16 |
| 5th row | 2017-08-02 18:43:15 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:43:31 | 63 | 0.1% |
| 2017-09-25 17:44:41 | 38 | < 0.1% |
| 2017-04-22 09:10:13 | 29 | < 0.1% |
| 2017-06-09 16:15:08 | 26 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2018-05-12 15:41:58 | 24 | < 0.1% |
| 2017-07-07 15:10:17 | 24 | < 0.1% |
| 2018-02-21 12:28:15 | 24 | < 0.1% |
| 2017-11-25 14:16:34 | 24 | < 0.1% |
| 2018-02-24 03:20:27 | 23 | < 0.1% |
| Other values (90723) | 118667 | |
| (Missing) | 177 | 0.1% |
Length
| Value | Count | Frequency (%) |
| 2018-04-24 | 1163 | 0.5% |
| 2017-11-24 | 1000 | 0.4% |
| 2017-11-25 | 943 | 0.4% |
| 2018-07-05 | 825 | 0.3% |
| 2017-11-28 | 607 | 0.3% |
| 2018-08-07 | 505 | 0.2% |
| 2018-05-08 | 498 | 0.2% |
| 2018-01-22 | 489 | 0.2% |
| 2018-08-20 | 488 | 0.2% |
| 2018-05-01 | 487 | 0.2% |
| Other values (42347) | 230927 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 381200 | |
| 1 | 366273 | |
| 2 | 289265 | |
| - | 237932 | |
| : | 237932 | |
| 118966 | 5.3% | |
| 8 | 116954 | 5.2% |
| 5 | 114527 | 5.1% |
| 3 | 111559 | 4.9% |
| 7 | 105817 | 4.7% |
| Other values (3) | 179929 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1665524 | |
| Dash Punctuation | 237932 | 10.5% |
| Other Punctuation | 237932 | 10.5% |
| Space Separator | 118966 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 381200 | |
| 1 | 366273 | |
| 2 | 289265 | |
| 8 | 116954 | 7.0% |
| 5 | 114527 | 6.9% |
| 3 | 111559 | 6.7% |
| 7 | 105817 | 6.4% |
| 4 | 82414 | 4.9% |
| 6 | 51368 | 3.1% |
| 9 | 46147 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 237932 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 237932 |
Space Separator
| Value | Count | Frequency (%) |
| 118966 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2260354 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 381200 | |
| 1 | 366273 | |
| 2 | 289265 | |
| - | 237932 | |
| : | 237932 | |
| 118966 | 5.3% | |
| 8 | 116954 | 5.2% |
| 5 | 114527 | 5.1% |
| 3 | 111559 | 4.9% |
| 7 | 105817 | 4.7% |
| Other values (3) | 179929 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2260354 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 381200 | |
| 1 | 366273 | |
| 2 | 289265 | |
| - | 237932 | |
| : | 237932 | |
| 118966 | 5.3% | |
| 8 | 116954 | 5.2% |
| 5 | 114527 | 5.1% |
| 3 | 111559 | 4.9% |
| 7 | 105817 | 4.7% |
| Other values (3) | 179929 |
order_delivered_carrier_date
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 81018 |
|---|---|
| Distinct (%) | 69.2% |
| Missing | 2086 |
| Missing (%) | 1.8% |
| Memory size | 1.8 MiB |
| 2017-08-10 11:58:14 | 63 |
|---|---|
| 2018-05-09 15:48:00 | 48 |
| 2017-10-02 23:47:54 | 38 |
| 2018-05-10 18:29:00 | 36 |
| 2018-05-14 14:25:00 | 32 |
| Other values (81013) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2224083 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 61382 ? |
|---|---|
| Unique (%) | 52.4% |
Sample
| 1st row | 2017-10-04 19:55:00 |
|---|---|
| 2nd row | 2017-10-04 19:55:00 |
| 3rd row | 2017-10-04 19:55:00 |
| 4th row | 2017-08-17 15:28:33 |
| 5th row | 2017-08-04 17:35:43 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-10 11:58:14 | 63 | 0.1% |
| 2018-05-09 15:48:00 | 48 | < 0.1% |
| 2017-10-02 23:47:54 | 38 | < 0.1% |
| 2018-05-10 18:29:00 | 36 | < 0.1% |
| 2018-05-14 14:25:00 | 32 | < 0.1% |
| 2017-04-24 11:31:17 | 29 | < 0.1% |
| 2018-05-04 15:46:00 | 29 | < 0.1% |
| 2018-08-08 15:01:00 | 27 | < 0.1% |
| 2017-06-16 15:50:28 | 26 | < 0.1% |
| 2018-06-13 14:13:00 | 24 | < 0.1% |
| Other values (81008) | 116705 | |
| (Missing) | 2086 | 1.8% |
Length
| Value | Count | Frequency (%) |
| 2017-11-28 | 925 | 0.4% |
| 2017-11-27 | 818 | 0.3% |
| 2017-11-29 | 706 | 0.3% |
| 2018-02-27 | 632 | 0.3% |
| 2018-03-27 | 622 | 0.3% |
| 2018-08-06 | 595 | 0.3% |
| 2017-11-30 | 584 | 0.2% |
| 2018-05-14 | 568 | 0.2% |
| 2018-08-13 | 550 | 0.2% |
| 2018-05-03 | 539 | 0.2% |
| Other values (37539) | 227575 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 405304 | |
| 1 | 346875 | |
| 2 | 275757 | |
| - | 234114 | |
| : | 234114 | |
| 8 | 123405 | 5.5% |
| 117057 | 5.3% | |
| 7 | 106647 | 4.8% |
| 3 | 98637 | 4.4% |
| 4 | 92061 | 4.1% |
| Other values (3) | 190112 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1638798 | |
| Dash Punctuation | 234114 | 10.5% |
| Other Punctuation | 234114 | 10.5% |
| Space Separator | 117057 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 405304 | |
| 1 | 346875 | |
| 2 | 275757 | |
| 8 | 123405 | 7.5% |
| 7 | 106647 | 6.5% |
| 3 | 98637 | 6.0% |
| 4 | 92061 | 5.6% |
| 5 | 89897 | 5.5% |
| 6 | 51437 | 3.1% |
| 9 | 48778 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 234114 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 234114 |
Space Separator
| Value | Count | Frequency (%) |
| 117057 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2224083 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 405304 | |
| 1 | 346875 | |
| 2 | 275757 | |
| - | 234114 | |
| : | 234114 | |
| 8 | 123405 | 5.5% |
| 117057 | 5.3% | |
| 7 | 106647 | 4.8% |
| 3 | 98637 | 4.4% |
| 4 | 92061 | 4.1% |
| Other values (3) | 190112 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2224083 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 405304 | |
| 1 | 346875 | |
| 2 | 275757 | |
| - | 234114 | |
| : | 234114 | |
| 8 | 123405 | 5.5% |
| 117057 | 5.3% | |
| 7 | 106647 | 4.8% |
| 3 | 98637 | 4.4% |
| 4 | 92061 | 4.1% |
| Other values (3) | 190112 |
order_delivered_customer_date
Categorical
HIGH CARDINALITY  MISSING  UNIFORM 
| Distinct | 95664 |
|---|---|
| Distinct (%) | 82.7% |
| Missing | 3421 |
| Missing (%) | 2.9% |
| Memory size | 1.8 MiB |
| 2017-08-14 12:46:18 | 63 |
|---|---|
| 2017-10-18 22:35:50 | 38 |
| 2017-06-22 16:04:46 | 26 |
| 2017-11-30 14:59:18 | 24 |
| 2018-02-28 20:09:19 | 24 |
| Other values (95659) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2198718 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 82390 ? |
|---|---|
| Unique (%) | 71.2% |
Sample
| 1st row | 2017-10-10 21:25:13 |
|---|---|
| 2nd row | 2017-10-10 21:25:13 |
| 3rd row | 2017-10-10 21:25:13 |
| 4th row | 2017-08-18 14:44:43 |
| 5th row | 2017-08-07 18:30:01 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 12:46:18 | 63 | 0.1% |
| 2017-10-18 22:35:50 | 38 | < 0.1% |
| 2017-06-22 16:04:46 | 26 | < 0.1% |
| 2017-11-30 14:59:18 | 24 | < 0.1% |
| 2018-02-28 20:09:19 | 24 | < 0.1% |
| 2017-07-27 20:52:15 | 24 | < 0.1% |
| 2017-03-21 13:32:45 | 24 | < 0.1% |
| 2018-06-01 15:18:45 | 24 | < 0.1% |
| 2017-12-21 16:33:10 | 22 | < 0.1% |
| 2017-10-22 14:43:54 | 22 | < 0.1% |
| Other values (95654) | 115431 | |
| (Missing) | 3421 | 2.9% |
Length
| Value | Count | Frequency (%) |
| 2018-05-21 | 529 | 0.2% |
| 2018-05-14 | 528 | 0.2% |
| 2018-08-13 | 507 | 0.2% |
| 2018-05-18 | 505 | 0.2% |
| 2018-08-27 | 504 | 0.2% |
| 2018-05-03 | 501 | 0.2% |
| 2018-04-11 | 495 | 0.2% |
| 2017-12-11 | 489 | 0.2% |
| 2017-12-19 | 484 | 0.2% |
| 2017-06-19 | 482 | 0.2% |
| Other values (41734) | 226420 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 340122 | |
| 0 | 336673 | |
| 2 | 291213 | |
| - | 231444 | |
| : | 231444 | |
| 8 | 135442 | 6.2% |
| 115722 | 5.3% | |
| 7 | 107273 | 4.9% |
| 3 | 107058 | 4.9% |
| 4 | 100137 | 4.6% |
| Other values (3) | 202190 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620108 | |
| Dash Punctuation | 231444 | 10.5% |
| Other Punctuation | 231444 | 10.5% |
| Space Separator | 115722 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 340122 | |
| 0 | 336673 | |
| 2 | 291213 | |
| 8 | 135442 | 8.4% |
| 7 | 107273 | 6.6% |
| 3 | 107058 | 6.6% |
| 4 | 100137 | 6.2% |
| 5 | 93750 | 5.8% |
| 6 | 58489 | 3.6% |
| 9 | 49951 | 3.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 231444 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 231444 |
Space Separator
| Value | Count | Frequency (%) |
| 115722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2198718 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 340122 | |
| 0 | 336673 | |
| 2 | 291213 | |
| - | 231444 | |
| : | 231444 | |
| 8 | 135442 | 6.2% |
| 115722 | 5.3% | |
| 7 | 107273 | 4.9% |
| 3 | 107058 | 4.9% |
| 4 | 100137 | 4.6% |
| Other values (3) | 202190 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2198718 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 340122 | |
| 0 | 336673 | |
| 2 | 291213 | |
| - | 231444 | |
| : | 231444 | |
| 8 | 135442 | 6.2% |
| 115722 | 5.3% | |
| 7 | 107273 | 4.9% |
| 3 | 107058 | 4.9% |
| 4 | 100137 | 4.6% |
| Other values (3) | 202190 |
order_estimated_delivery_date
Categorical
| Distinct | 459 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| 2017-12-20 00:00:00 | 663 |
|---|---|
| 2018-03-13 00:00:00 | 620 |
| 2018-03-12 00:00:00 | 618 |
| 2018-05-29 00:00:00 | 612 |
| 2018-05-30 00:00:00 | 591 |
| Other values (454) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2263717 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-10-18 00:00:00 |
|---|---|
| 2nd row | 2017-10-18 00:00:00 |
| 3rd row | 2017-10-18 00:00:00 |
| 4th row | 2017-08-28 00:00:00 |
| 5th row | 2017-08-15 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-20 00:00:00 | 663 | 0.6% |
| 2018-03-13 00:00:00 | 620 | 0.5% |
| 2018-03-12 00:00:00 | 618 | 0.5% |
| 2018-05-29 00:00:00 | 612 | 0.5% |
| 2018-05-30 00:00:00 | 591 | 0.5% |
| 2018-02-14 00:00:00 | 590 | 0.5% |
| 2018-07-16 00:00:00 | 590 | 0.5% |
| 2018-07-05 00:00:00 | 588 | 0.5% |
| 2018-02-06 00:00:00 | 587 | 0.5% |
| 2017-12-19 00:00:00 | 587 | 0.5% |
| Other values (449) | 113097 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 119143 | |
| 2017-12-20 | 663 | 0.3% |
| 2018-03-13 | 620 | 0.3% |
| 2018-03-12 | 618 | 0.3% |
| 2018-05-29 | 612 | 0.3% |
| 2018-05-30 | 591 | 0.2% |
| 2018-02-14 | 590 | 0.2% |
| 2018-07-16 | 590 | 0.2% |
| 2018-07-05 | 588 | 0.2% |
| 2018-02-06 | 587 | 0.2% |
| Other values (450) | 113684 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 985406 | |
| - | 238286 | 10.5% |
| : | 238286 | 10.5% |
| 1 | 204158 | 9.0% |
| 2 | 185778 | 8.2% |
| 119143 | 5.3% | |
| 8 | 98222 | 4.3% |
| 7 | 72819 | 3.2% |
| 3 | 31950 | 1.4% |
| 5 | 24449 | 1.1% |
| Other values (3) | 65220 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1668002 | |
| Dash Punctuation | 238286 | 10.5% |
| Other Punctuation | 238286 | 10.5% |
| Space Separator | 119143 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 985406 | |
| 1 | 204158 | 12.2% |
| 2 | 185778 | 11.1% |
| 8 | 98222 | 5.9% |
| 7 | 72819 | 4.4% |
| 3 | 31950 | 1.9% |
| 5 | 24449 | 1.5% |
| 6 | 23221 | 1.4% |
| 4 | 22239 | 1.3% |
| 9 | 19760 | 1.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 238286 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 238286 |
Space Separator
| Value | Count | Frequency (%) |
| 119143 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2263717 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 985406 | |
| - | 238286 | 10.5% |
| : | 238286 | 10.5% |
| 1 | 204158 | 9.0% |
| 2 | 185778 | 8.2% |
| 119143 | 5.3% | |
| 8 | 98222 | 4.3% |
| 7 | 72819 | 3.2% |
| 3 | 31950 | 1.4% |
| 5 | 24449 | 1.1% |
| Other values (3) | 65220 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2263717 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 985406 | |
| - | 238286 | 10.5% |
| : | 238286 | 10.5% |
| 1 | 204158 | 9.0% |
| 2 | 185778 | 8.2% |
| 119143 | 5.3% | |
| 8 | 98222 | 4.3% |
| 7 | 72819 | 3.2% |
| 3 | 31950 | 1.4% |
| 5 | 24449 | 1.1% |
| Other values (3) | 65220 | 2.9% |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 1.8 MiB |
| 5.0 | |
|---|---|
| 4.0 | |
| 1.0 | |
| 3.0 | |
| 2.0 | 4162 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 354438 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 4.0 |
| 4th row | 4.0 |
| 5th row | 5.0 |
Common Values
| Value | Count | Frequency (%) |
| 5.0 | 66343 | |
| 4.0 | 22319 | 18.7% |
| 1.0 | 15428 | 12.9% |
| 3.0 | 9894 | 8.3% |
| 2.0 | 4162 | 3.5% |
| (Missing) | 997 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5.0 | 66343 | |
| 4.0 | 22319 | 18.9% |
| 1.0 | 15428 | 13.1% |
| 3.0 | 9894 | 8.4% |
| 2.0 | 4162 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 236292 | |
| Other Punctuation | 118146 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 9.4% |
| 1 | 15428 | 6.5% |
| 3 | 9894 | 4.2% |
| 2 | 4162 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 118146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 354438 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 354438 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
review_creation_date
Categorical
| Distinct | 636 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 1.8 MiB |
| 2017-12-19 00:00:00 | 547 |
|---|---|
| 2018-05-22 00:00:00 | 521 |
| 2018-05-15 00:00:00 | 517 |
| 2017-12-20 00:00:00 | 515 |
| 2018-05-19 00:00:00 | 509 |
| Other values (631) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2244774 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-10-11 00:00:00 |
|---|---|
| 2nd row | 2017-10-11 00:00:00 |
| 3rd row | 2017-10-11 00:00:00 |
| 4th row | 2017-08-19 00:00:00 |
| 5th row | 2017-08-08 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-19 00:00:00 | 547 | 0.5% |
| 2018-05-22 00:00:00 | 521 | 0.4% |
| 2018-05-15 00:00:00 | 517 | 0.4% |
| 2017-12-20 00:00:00 | 515 | 0.4% |
| 2018-05-19 00:00:00 | 509 | 0.4% |
| 2018-08-28 00:00:00 | 507 | 0.4% |
| 2018-03-29 00:00:00 | 504 | 0.4% |
| 2018-05-04 00:00:00 | 504 | 0.4% |
| 2018-04-12 00:00:00 | 486 | 0.4% |
| 2018-03-30 00:00:00 | 485 | 0.4% |
| Other values (626) | 113051 | |
| (Missing) | 997 | 0.8% |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 118049 | |
| 2017-12-19 | 547 | 0.2% |
| 2018-05-22 | 521 | 0.2% |
| 2018-05-15 | 517 | 0.2% |
| 2017-12-20 | 515 | 0.2% |
| 2018-05-19 | 509 | 0.2% |
| 2018-08-28 | 507 | 0.2% |
| 2018-03-29 | 504 | 0.2% |
| 2018-05-04 | 504 | 0.2% |
| 2018-04-12 | 486 | 0.2% |
| Other values (628) | 113633 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 973738 | |
| - | 236292 | 10.5% |
| : | 236292 | 10.5% |
| 1 | 205175 | 9.1% |
| 2 | 188753 | 8.4% |
| 118146 | 5.3% | |
| 8 | 94367 | 4.2% |
| 7 | 74321 | 3.3% |
| 3 | 29057 | 1.3% |
| 5 | 25233 | 1.1% |
| Other values (3) | 63400 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1654044 | |
| Dash Punctuation | 236292 | 10.5% |
| Other Punctuation | 236292 | 10.5% |
| Space Separator | 118146 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 973738 | |
| 1 | 205175 | 12.4% |
| 2 | 188753 | 11.4% |
| 8 | 94367 | 5.7% |
| 7 | 74321 | 4.5% |
| 3 | 29057 | 1.8% |
| 5 | 25233 | 1.5% |
| 4 | 23694 | 1.4% |
| 6 | 23414 | 1.4% |
| 9 | 16292 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236292 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236292 |
Space Separator
| Value | Count | Frequency (%) |
| 118146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2244774 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 973738 | |
| - | 236292 | 10.5% |
| : | 236292 | 10.5% |
| 1 | 205175 | 9.1% |
| 2 | 188753 | 8.4% |
| 118146 | 5.3% | |
| 8 | 94367 | 4.2% |
| 7 | 74321 | 3.3% |
| 3 | 29057 | 1.3% |
| 5 | 25233 | 1.1% |
| Other values (3) | 63400 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2244774 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 973738 | |
| - | 236292 | 10.5% |
| : | 236292 | 10.5% |
| 1 | 205175 | 9.1% |
| 2 | 188753 | 8.4% |
| 118146 | 5.3% | |
| 8 | 94367 | 4.2% |
| 7 | 74321 | 3.3% |
| 3 | 29057 | 1.3% |
| 5 | 25233 | 1.1% |
| Other values (3) | 63400 | 2.8% |
review_answer_timestamp
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 98248 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 1.8 MiB |
| 2017-08-17 22:17:55 | 63 |
|---|---|
| 2017-10-19 21:08:44 | 38 |
| 2017-05-24 16:21:27 | 29 |
| 2017-06-28 18:49:50 | 26 |
| 2018-03-07 15:08:10 | 24 |
| Other values (98243) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2244774 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 85133 ? |
|---|---|
| Unique (%) | 72.1% |
Sample
| 1st row | 2017-10-12 03:43:48 |
|---|---|
| 2nd row | 2017-10-12 03:43:48 |
| 3rd row | 2017-10-12 03:43:48 |
| 4th row | 2017-08-20 15:16:36 |
| 5th row | 2017-08-08 23:26:23 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-17 22:17:55 | 63 | 0.1% |
| 2017-10-19 21:08:44 | 38 | < 0.1% |
| 2017-05-24 16:21:27 | 29 | < 0.1% |
| 2017-06-28 18:49:50 | 26 | < 0.1% |
| 2018-03-07 15:08:10 | 24 | < 0.1% |
| 2018-06-04 19:04:20 | 24 | < 0.1% |
| 2017-03-23 08:34:13 | 24 | < 0.1% |
| 2017-08-01 13:20:31 | 24 | < 0.1% |
| 2017-12-22 20:33:52 | 22 | < 0.1% |
| 2018-02-19 20:04:36 | 21 | < 0.1% |
| Other values (98238) | 117851 | |
| (Missing) | 997 | 0.8% |
Length
| Value | Count | Frequency (%) |
| 2018-05-20 | 781 | 0.3% |
| 2018-05-21 | 684 | 0.3% |
| 2018-05-10 | 593 | 0.3% |
| 2017-12-20 | 472 | 0.2% |
| 2018-04-13 | 432 | 0.2% |
| 2017-12-13 | 421 | 0.2% |
| 2017-12-22 | 421 | 0.2% |
| 2018-08-24 | 418 | 0.2% |
| 2018-05-11 | 414 | 0.2% |
| 2017-12-21 | 412 | 0.2% |
| Other values (53983) | 231244 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 378113 | |
| 1 | 350346 | |
| 2 | 299408 | |
| - | 236292 | |
| : | 236292 | |
| 8 | 124163 | 5.5% |
| 118146 | 5.3% | |
| 3 | 109822 | 4.9% |
| 7 | 102251 | 4.6% |
| 5 | 93511 | 4.2% |
| Other values (3) | 196430 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1654044 | |
| Dash Punctuation | 236292 | 10.5% |
| Other Punctuation | 236292 | 10.5% |
| Space Separator | 118146 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 378113 | |
| 1 | 350346 | |
| 2 | 299408 | |
| 8 | 124163 | 7.5% |
| 3 | 109822 | 6.6% |
| 7 | 102251 | 6.2% |
| 5 | 93511 | 5.7% |
| 4 | 93373 | 5.6% |
| 6 | 53342 | 3.2% |
| 9 | 49715 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236292 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236292 |
Space Separator
| Value | Count | Frequency (%) |
| 118146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2244774 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 378113 | |
| 1 | 350346 | |
| 2 | 299408 | |
| - | 236292 | |
| : | 236292 | |
| 8 | 124163 | 5.5% |
| 118146 | 5.3% | |
| 3 | 109822 | 4.9% |
| 7 | 102251 | 4.6% |
| 5 | 93511 | 4.2% |
| Other values (3) | 196430 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2244774 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 378113 | |
| 1 | 350346 | |
| 2 | 299408 | |
| - | 236292 | |
| : | 236292 | |
| 8 | 124163 | 5.5% |
| 118146 | 5.3% | |
| 3 | 109822 | 4.9% |
| 7 | 102251 | 4.6% |
| 5 | 93511 | 4.2% |
| Other values (3) | 196430 |
length_comment_title
Real number (ℝ)
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4256682 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 104159 |
| Zeros (%) | 87.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 13 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.4658155 |
|---|---|
| Coefficient of variation (CV) | 3.1324367 |
| Kurtosis | 11.168711 |
| Mean | 1.4256682 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.3991733 |
| Sum | 168437 |
| Variance | 19.943508 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 104159 | |
| 9 | 2347 | 2.0% |
| 5 | 1259 | 1.1% |
| 15 | 1041 | 0.9% |
| 3 | 804 | 0.7% |
| 10 | 685 | 0.6% |
| 13 | 618 | 0.5% |
| 17 | 616 | 0.5% |
| 25 | 575 | 0.5% |
| 16 | 528 | 0.4% |
| Other values (17) | 5514 | 4.6% |
| (Missing) | 997 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 104159 | |
| 1 | 191 | 0.2% |
| 2 | 300 | 0.3% |
| 3 | 804 | 0.7% |
| 4 | 226 | 0.2% |
| 5 | 1259 | 1.1% |
| 6 | 282 | 0.2% |
| 7 | 450 | 0.4% |
| 8 | 407 | 0.3% |
| 9 | 2347 | 2.0% |
| Value | Count | Frequency (%) |
| 26 | 2 | < 0.1% |
| 25 | 575 | |
| 24 | 299 | |
| 23 | 253 | |
| 22 | 265 | |
| 21 | 319 | |
| 20 | 484 | |
| 19 | 331 | |
| 18 | 413 | |
| 17 | 616 |
length_comment_message
Real number (ℝ)
| Distinct | 209 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.929579 |
| Minimum | 0 |
|---|---|
| Maximum | 208 |
| Zeros | 67932 |
| Zeros (%) | 57.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 44 |
| 95-th percentile | 154 |
| Maximum | 208 |
| Range | 208 |
| Interquartile range (IQR) | 44 |
Descriptive statistics
| Standard deviation | 49.834722 |
|---|---|
| Coefficient of variation (CV) | 1.6650659 |
| Kurtosis | 2.8705156 |
| Mean | 29.929579 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8936024 |
| Sum | 3536060 |
| Variance | 2483.4995 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 67932 | |
| 9 | 1144 | 1.0% |
| 200 | 806 | 0.7% |
| 5 | 651 | 0.5% |
| 26 | 617 | 0.5% |
| 10 | 594 | 0.5% |
| 20 | 584 | 0.5% |
| 3 | 571 | 0.5% |
| 30 | 561 | 0.5% |
| 35 | 547 | 0.5% |
| Other values (199) | 44139 | |
| (Missing) | 997 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 67932 | |
| 1 | 109 | 0.1% |
| 2 | 233 | 0.2% |
| 3 | 571 | 0.5% |
| 4 | 129 | 0.1% |
| 5 | 651 | 0.5% |
| 6 | 214 | 0.2% |
| 7 | 285 | 0.2% |
| 8 | 294 | 0.2% |
| 9 | 1144 | 1.0% |
| Value | Count | Frequency (%) |
| 208 | 1 | < 0.1% |
| 207 | 1 | < 0.1% |
| 206 | 1 | < 0.1% |
| 205 | 1 | < 0.1% |
| 204 | 17 | < 0.1% |
| 203 | 21 | < 0.1% |
| 202 | 20 | < 0.1% |
| 201 | 29 | < 0.1% |
| 200 | 806 | |
| 199 | 452 |
payment_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 1.8 MiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6465 |
| debit_card | 1706 |
| not_defined | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.7954004 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1167024 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | voucher |
| 3rd row | voucher |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 87776 | |
| boleto | 23190 | 19.5% |
| voucher | 6465 | 5.4% |
| debit_card | 1706 | 1.4% |
| not_defined | 3 | < 0.1% |
| (Missing) | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit_card | 87776 | |
| boleto | 23190 | 19.5% |
| voucher | 6465 | 5.4% |
| debit_card | 1706 | 1.4% |
| not_defined | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1077539 | |
| Connector Punctuation | 89485 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| a | 89482 | |
| o | 52848 | 4.9% |
| b | 24896 | 2.3% |
| l | 23190 | 2.2% |
| Other values (5) | 19404 | 1.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 89485 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1077539 | |
| Common | 89485 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| a | 89482 | |
| o | 52848 | 4.9% |
| b | 24896 | 2.3% |
| l | 23190 | 2.2% |
| Other values (5) | 19404 | 1.8% |
Common
| Value | Count | Frequency (%) |
| _ | 89485 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1167024 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9412456 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7778477 |
|---|---|
| Coefficient of variation (CV) | 0.94444604 |
| Kurtosis | 2.5065453 |
| Mean | 2.9412456 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6198199 |
| Sum | 350420 |
| Variance | 7.7164381 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 59446 | |
| 2 | 13838 | 11.6% |
| 3 | 11889 | 10.0% |
| 4 | 8072 | 6.8% |
| 10 | 6976 | 5.9% |
| 5 | 6097 | 5.1% |
| 8 | 5120 | 4.3% |
| 6 | 4674 | 3.9% |
| 7 | 1848 | 1.6% |
| 9 | 739 | 0.6% |
| Other values (14) | 441 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 59446 | |
| 2 | 13838 | 11.6% |
| 3 | 11889 | 10.0% |
| 4 | 8072 | 6.8% |
| 5 | 6097 | 5.1% |
| 6 | 4674 | 3.9% |
| 7 | 1848 | 1.6% |
| 8 | 5120 | 4.3% |
| 9 | 739 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 21 | < 0.1% |
| 18 | 38 | |
| 17 | 8 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 93 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
| Distinct | 29077 |
|---|---|
| Distinct (%) | 24.4% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.73514 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.1 |
| Q1 | 60.85 |
| median | 108.16 |
| Q3 | 189.24 |
| 95-th percentile | 515.93 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.39 |
Descriptive statistics
| Standard deviation | 267.77608 |
|---|---|
| Coefficient of variation (CV) | 1.550212 |
| Kurtosis | 500.3632 |
| Mean | 172.73514 |
| Median Absolute Deviation (MAD) | 56.64 |
| Skewness | 13.965989 |
| Sum | 20579664 |
| Variance | 71704.027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 351 | 0.3% |
| 100 | 300 | 0.3% |
| 20 | 286 | 0.2% |
| 77.57 | 250 | 0.2% |
| 35 | 166 | 0.1% |
| 73.34 | 160 | 0.1% |
| 30 | 139 | 0.1% |
| 116.94 | 133 | 0.1% |
| 56.78 | 123 | 0.1% |
| 107.78 | 120 | 0.1% |
| Other values (29067) | 117112 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | < 0.1% |
| 0.11 | 2 | < 0.1% |
| 0.13 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6922.21 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
shipping_limit_date
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 93318 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 1.8 MiB |
| 2017-08-14 20:43:31 | 63 |
|---|---|
| 2017-10-05 17:44:41 | 38 |
| 2017-04-27 09:10:13 | 29 |
| 2017-06-15 16:15:08 | 26 |
| 2017-11-30 14:16:34 | 24 |
| Other values (93313) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2247890 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 76920 ? |
|---|---|
| Unique (%) | 65.0% |
Sample
| 1st row | 2017-10-06 11:07:15 |
|---|---|
| 2nd row | 2017-10-06 11:07:15 |
| 3rd row | 2017-10-06 11:07:15 |
| 4th row | 2017-08-21 20:05:16 |
| 5th row | 2017-08-08 18:37:31 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 20:43:31 | 63 | 0.1% |
| 2017-10-05 17:44:41 | 38 | < 0.1% |
| 2017-04-27 09:10:13 | 29 | < 0.1% |
| 2017-06-15 16:15:08 | 26 | < 0.1% |
| 2017-11-30 14:16:34 | 24 | < 0.1% |
| 2018-05-15 15:30:28 | 24 | < 0.1% |
| 2018-02-27 12:28:15 | 24 | < 0.1% |
| 2017-07-13 15:10:17 | 24 | < 0.1% |
| 2017-03-15 23:39:26 | 24 | < 0.1% |
| 2017-10-24 13:06:21 | 22 | < 0.1% |
| Other values (93308) | 118012 | |
| (Missing) | 833 | 0.7% |
Length
| Value | Count | Frequency (%) |
| 2017-11-30 | 1753 | 0.7% |
| 2017-12-07 | 794 | 0.3% |
| 2018-04-19 | 729 | 0.3% |
| 2018-05-10 | 696 | 0.3% |
| 2018-01-18 | 689 | 0.3% |
| 2018-03-08 | 681 | 0.3% |
| 2018-08-07 | 678 | 0.3% |
| 2018-02-22 | 673 | 0.3% |
| 2018-03-22 | 670 | 0.3% |
| 2018-03-01 | 663 | 0.3% |
| Other values (40675) | 228594 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 379298 | |
| 1 | 364436 | |
| 2 | 289766 | |
| - | 236620 | |
| : | 236620 | |
| 8 | 118667 | 5.3% |
| 118310 | 5.3% | |
| 3 | 114161 | 5.1% |
| 5 | 111987 | 5.0% |
| 7 | 102121 | 4.5% |
| Other values (3) | 175904 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1656340 | |
| Dash Punctuation | 236620 | 10.5% |
| Other Punctuation | 236620 | 10.5% |
| Space Separator | 118310 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 379298 | |
| 1 | 364436 | |
| 2 | 289766 | |
| 8 | 118667 | 7.2% |
| 3 | 114161 | 6.9% |
| 5 | 111987 | 6.8% |
| 7 | 102121 | 6.2% |
| 4 | 79394 | 4.8% |
| 6 | 49607 | 3.0% |
| 9 | 46903 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236620 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 236620 |
Space Separator
| Value | Count | Frequency (%) |
| 118310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2247890 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 379298 | |
| 1 | 364436 | |
| 2 | 289766 | |
| - | 236620 | |
| : | 236620 | |
| 8 | 118667 | 5.3% |
| 118310 | 5.3% | |
| 3 | 114161 | 5.1% |
| 5 | 111987 | 5.0% |
| 7 | 102121 | 4.5% |
| Other values (3) | 175904 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2247890 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 379298 | |
| 1 | 364436 | |
| 2 | 289766 | |
| - | 236620 | |
| : | 236620 | |
| 8 | 118667 | 5.3% |
| 118310 | 5.3% | |
| 3 | 114161 | 5.1% |
| 5 | 111987 | 5.0% |
| 7 | 102121 | 4.5% |
| Other values (3) | 175904 |
price
Real number (ℝ)
| Distinct | 5968 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.6466 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 184.10969 |
|---|---|
| Coefficient of variation (CV) | 1.5260247 |
| Kurtosis | 119.15494 |
| Mean | 120.6466 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.8925735 |
| Sum | 14273700 |
| Variance | 33896.378 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2619 | 2.2% |
| 69.9 | 2113 | 1.8% |
| 49.9 | 2051 | 1.7% |
| 89.9 | 1644 | 1.4% |
| 99.9 | 1526 | 1.3% |
| 39.9 | 1403 | 1.2% |
| 29.9 | 1387 | 1.2% |
| 19.9 | 1284 | 1.1% |
| 79.9 | 1282 | 1.1% |
| 29.99 | 1228 | 1.0% |
| Other values (5958) | 101773 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6999 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.032387 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 390 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.28 |
| Q3 | 21.18 |
| 95-th percentile | 45.3 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.1 |
Descriptive statistics
| Standard deviation | 15.83685 |
|---|---|
| Coefficient of variation (CV) | 0.79056234 |
| Kurtosis | 57.635327 |
| Mean | 20.032387 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5433839 |
| Sum | 2370031.6 |
| Variance | 250.80583 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3861 | 3.2% |
| 7.78 | 2355 | 2.0% |
| 11.85 | 1999 | 1.7% |
| 14.1 | 1992 | 1.7% |
| 18.23 | 1632 | 1.4% |
| 7.39 | 1573 | 1.3% |
| 16.11 | 1211 | 1.0% |
| 15.23 | 1064 | 0.9% |
| 8.72 | 970 | 0.8% |
| 16.79 | 930 | 0.8% |
| Other values (6989) | 100723 |
| Value | Count | Frequency (%) |
| 0 | 390 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
customer_city
Categorical
| Distinct | 4119 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| sao paulo | |
|---|---|
| rio de janeiro | 8311 |
| belo horizonte | 3299 |
| brasilia | 2500 |
| curitiba | 1827 |
| Other values (4114) |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.33532 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1231381 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1036 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | sao paulo |
| 3rd row | sao paulo |
| 4th row | sao paulo |
| 5th row | sao paulo |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 18875 | 15.8% |
| rio de janeiro | 8311 | 7.0% |
| belo horizonte | 3299 | 2.8% |
| brasilia | 2500 | 2.1% |
| curitiba | 1827 | 1.5% |
| campinas | 1757 | 1.5% |
| porto alegre | 1675 | 1.4% |
| salvador | 1544 | 1.3% |
| guarulhos | 1415 | 1.2% |
| sao bernardo do campo | 1131 | 0.9% |
| Other values (4109) | 76809 |
Length
| Value | Count | Frequency (%) |
| sao | 25445 | 12.2% |
| paulo | 18957 | 9.1% |
| de | 11657 | 5.6% |
| rio | 9967 | 4.8% |
| janeiro | 8311 | 4.0% |
| do | 5095 | 2.4% |
| belo | 3373 | 1.6% |
| horizonte | 3327 | 1.6% |
| brasilia | 2510 | 1.2% |
| porto | 1998 | 1.0% |
| Other values (3285) | 118347 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1140982 | |
| Space Separator | 89844 | 7.3% |
| Dash Punctuation | 290 | < 0.1% |
| Other Punctuation | 263 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 8.3% |
| r | 91236 | 8.0% |
| e | 79953 | 7.0% |
| s | 75446 | 6.6% |
| n | 54566 | 4.8% |
| u | 54064 | 4.7% |
| l | 53676 | 4.7% |
| p | 44782 | 3.9% |
| Other values (16) | 238036 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 89844 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 290 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1140982 | |
| Common | 90399 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 8.3% |
| r | 91236 | 8.0% |
| e | 79953 | 7.0% |
| s | 75446 | 6.6% |
| n | 54566 | 4.8% |
| u | 54064 | 4.7% |
| l | 53676 | 4.7% |
| p | 44782 | 3.9% |
| Other values (16) | 238036 |
Common
| Value | Count | Frequency (%) |
| 89844 | ||
| - | 290 | 0.3% |
| ' | 263 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1231381 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
customer_state
Categorical
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 238286 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 50265 | |
| RJ | 15518 | 13.0% |
| MG | 13819 | 11.6% |
| RS | 6573 | 5.5% |
| PR | 6043 | 5.1% |
| SC | 4345 | 3.6% |
| BA | 4091 | 3.4% |
| DF | 2516 | 2.1% |
| GO | 2466 | 2.1% |
| ES | 2360 | 2.0% |
| Other values (17) | 11147 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 50265 | |
| rj | 15518 | 13.0% |
| mg | 13819 | 11.6% |
| rs | 6573 | 5.5% |
| pr | 6043 | 5.1% |
| sc | 4345 | 3.6% |
| ba | 4091 | 3.4% |
| df | 2516 | 2.1% |
| go | 2466 | 2.1% |
| es | 2360 | 2.0% |
| Other values (17) | 11147 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 238286 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 238286 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 238286 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
product_description_lenght
Real number (ℝ)
| Distinct | 2961 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 774.61444 |
| Minimum | 0 |
|---|---|
| Maximum | 3992 |
| Zeros | 1709 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 135 |
| Q1 | 340 |
| median | 594 |
| Q3 | 977 |
| 95-th percentile | 2113 |
| Maximum | 3992 |
| Range | 3992 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 654.60589 |
|---|---|
| Coefficient of variation (CV) | 0.84507319 |
| Kurtosis | 4.8856742 |
| Mean | 774.61444 |
| Median Absolute Deviation (MAD) | 299 |
| Skewness | 1.9918057 |
| Sum | 91644634 |
| Variance | 428508.87 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1709 | 1.4% |
| 341 | 711 | 0.6% |
| 1893 | 667 | 0.6% |
| 348 | 648 | 0.5% |
| 903 | 594 | 0.5% |
| 492 | 594 | 0.5% |
| 245 | 587 | 0.5% |
| 366 | 537 | 0.5% |
| 236 | 516 | 0.4% |
| 340 | 487 | 0.4% |
| Other values (2951) | 111260 | |
| (Missing) | 833 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 1709 | |
| 4 | 6 | < 0.1% |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | < 0.1% |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | < 0.1% |
| 28 | 2 | < 0.1% |
| 30 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1733074 |
| Minimum | 0 |
|---|---|
| Maximum | 20 |
| Zeros | 1709 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7251844 |
|---|---|
| Coefficient of variation (CV) | 0.79380599 |
| Kurtosis | 4.7453186 |
| Mean | 2.1733074 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.8812261 |
| Sum | 257124 |
| Variance | 2.9762614 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58957 | |
| 2 | 23054 | 19.3% |
| 3 | 12978 | 10.9% |
| 4 | 8863 | 7.4% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 0 | 1709 | 1.4% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.6% |
| 10 | 354 | 0.3% |
| Other values (10) | 517 | 0.4% |
| (Missing) | 833 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 1709 | 1.4% |
| 1 | 58957 | |
| 2 | 23054 | 19.3% |
| 3 | 12978 | 10.9% |
| 4 | 8863 | 7.4% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.6% |
| 9 | 318 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 354 |
product_weight_g
Real number (ℝ)
| Distinct | 2204 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2112.2507 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3786.6951 |
|---|---|
| Coefficient of variation (CV) | 1.7927299 |
| Kurtosis | 16.01826 |
| Mean | 2112.2507 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5830918 |
| Sum | 2.4985814 × 108 |
| Variance | 14339060 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 7093 | 6.0% |
| 150 | 5410 | 4.5% |
| 250 | 4741 | 4.0% |
| 300 | 4429 | 3.7% |
| 400 | 3787 | 3.2% |
| 100 | 3666 | 3.1% |
| 350 | 3291 | 2.8% |
| 500 | 2856 | 2.4% |
| 600 | 2838 | 2.4% |
| 700 | 2148 | 1.8% |
| Other values (2194) | 78031 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 991 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 303 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.265145 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.189367 |
|---|---|
| Coefficient of variation (CV) | 0.53491788 |
| Kurtosis | 3.6785662 |
| Mean | 30.265145 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7456849 |
| Sum | 3580064 |
| Variance | 262.09561 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 18363 | 15.4% |
| 20 | 10999 | 9.2% |
| 30 | 7951 | 6.7% |
| 17 | 6202 | 5.2% |
| 18 | 5909 | 5.0% |
| 19 | 4898 | 4.1% |
| 25 | 4871 | 4.1% |
| 40 | 4360 | 3.7% |
| 22 | 4000 | 3.4% |
| 50 | 3163 | 2.7% |
| Other values (89) | 47574 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 138 | 0.1% |
| 15 | 220 | 0.2% |
| 16 | 18363 |
| Value | Count | Frequency (%) |
| 105 | 335 | |
| 104 | 35 | < 0.1% |
| 103 | 46 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 108 | 0.1% |
| 100 | 429 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.619706 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.453584 |
|---|---|
| Coefficient of variation (CV) | 0.80949592 |
| Kurtosis | 7.2778781 |
| Mean | 16.619706 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2389625 |
| Sum | 1965945 |
| Variance | 180.99892 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10374 | 8.7% |
| 20 | 6915 | 5.8% |
| 15 | 6896 | 5.8% |
| 12 | 6520 | 5.5% |
| 11 | 6432 | 5.4% |
| 2 | 5254 | 4.4% |
| 4 | 4910 | 4.1% |
| 8 | 4873 | 4.1% |
| 5 | 4776 | 4.0% |
| 16 | 4765 | 4.0% |
| Other values (92) | 56575 |
| Value | Count | Frequency (%) |
| 2 | 5254 | |
| 3 | 2821 | 2.4% |
| 4 | 4910 | |
| 5 | 4776 | |
| 6 | 3576 | 3.0% |
| 7 | 4387 | |
| 8 | 4873 | |
| 9 | 3408 | 2.9% |
| 10 | 10374 | |
| 11 | 6432 |
| Value | Count | Frequency (%) |
| 105 | 139 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 43 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.074799 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.749139 |
|---|---|
| Coefficient of variation (CV) | 0.50917622 |
| Kurtosis | 4.5530162 |
| Mean | 23.074799 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.707171 |
| Sum | 2729518 |
| Variance | 138.04227 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12701 | 10.7% |
| 11 | 11144 | 9.4% |
| 15 | 9376 | 7.9% |
| 16 | 8810 | 7.4% |
| 30 | 8045 | 6.8% |
| 12 | 5711 | 4.8% |
| 13 | 5491 | 4.6% |
| 14 | 4846 | 4.1% |
| 18 | 4192 | 3.5% |
| 40 | 4157 | 3.5% |
| Other values (85) | 43817 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 11144 | |
| 12 | 5711 | |
| 13 | 5491 | |
| 14 | 4846 | |
| 15 | 9376 |
| Value | Count | Frequency (%) |
| 118 | 8 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
product_category_name_english
Categorical
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 1.8 MiB |
| bed_bath_table | |
|---|---|
| health_beauty | |
| sports_leisure | |
| furniture_decor | |
| computers_accessories | |
| Other values (67) |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 12.900532 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1526262 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | housewares |
|---|---|
| 2nd row | housewares |
| 3rd row | housewares |
| 4th row | housewares |
| 5th row | housewares |
Common Values
| Value | Count | Frequency (%) |
| bed_bath_table | 11988 | 10.1% |
| health_beauty | 10032 | 8.4% |
| sports_leisure | 9004 | 7.6% |
| furniture_decor | 8832 | 7.4% |
| computers_accessories | 8150 | 6.8% |
| housewares | 7380 | 6.2% |
| watches_gifts | 6213 | 5.2% |
| telephony | 4726 | 4.0% |
| garden_tools | 4590 | 3.9% |
| auto | 4400 | 3.7% |
| Other values (62) | 42995 |
Length
| Value | Count | Frequency (%) |
| bed_bath_table | 11988 | 10.1% |
| health_beauty | 10032 | 8.5% |
| sports_leisure | 9004 | 7.6% |
| furniture_decor | 8832 | 7.5% |
| computers_accessories | 8150 | 6.9% |
| housewares | 7380 | 6.2% |
| watches_gifts | 6213 | 5.3% |
| telephony | 4726 | 4.0% |
| garden_tools | 4590 | 3.9% |
| auto | 4400 | 3.7% |
| Other values (62) | 42995 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.3% |
| t | 133341 | 8.7% |
| o | 113626 | 7.4% |
| r | 105808 | 6.9% |
| a | 102466 | 6.7% |
| _ | 102216 | 6.7% |
| u | 79961 | 5.2% |
| c | 72479 | 4.7% |
| i | 63331 | 4.1% |
| Other values (15) | 425679 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1423745 | |
| Connector Punctuation | 102216 | 6.7% |
| Decimal Number | 301 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 10.0% |
| t | 133341 | 9.4% |
| o | 113626 | 8.0% |
| r | 105808 | 7.4% |
| a | 102466 | 7.2% |
| u | 79961 | 5.6% |
| c | 72479 | 5.1% |
| i | 63331 | 4.4% |
| h | 59668 | 4.2% |
| Other values (13) | 365710 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 102216 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 301 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1423745 | |
| Common | 102517 | 6.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 10.0% |
| t | 133341 | 9.4% |
| o | 113626 | 8.0% |
| r | 105808 | 7.4% |
| a | 102466 | 7.2% |
| u | 79961 | 5.6% |
| c | 72479 | 5.1% |
| i | 63331 | 4.4% |
| h | 59668 | 4.2% |
| Other values (13) | 365710 |
Common
| Value | Count | Frequency (%) |
| _ | 102216 | |
| 2 | 301 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1526262 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.3% |
| t | 133341 | 8.7% |
| o | 113626 | 7.4% |
| r | 105808 | 6.9% |
| a | 102466 | 6.7% |
| _ | 102216 | 6.7% |
| u | 79961 | 5.2% |
| c | 72479 | 4.7% |
| i | 63331 | 4.1% |
| Other values (15) | 425679 |
seller_city
Categorical
| Distinct | 611 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 1.8 MiB |
| sao paulo | |
|---|---|
| ibitinga | |
| curitiba | 3161 |
| santo andre | 3149 |
| sao jose do rio preto | 2693 |
| Other values (606) |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 10.102451 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1195221 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 9 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | maua |
|---|---|
| 2nd row | maua |
| 3rd row | maua |
| 4th row | maua |
| 5th row | maua |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 29293 | |
| ibitinga | 8373 | 7.0% |
| curitiba | 3161 | 2.7% |
| santo andre | 3149 | 2.6% |
| sao jose do rio preto | 2693 | 2.3% |
| belo horizonte | 2688 | 2.3% |
| rio de janeiro | 2535 | 2.1% |
| guarulhos | 2456 | 2.1% |
| ribeirao preto | 2374 | 2.0% |
| maringa | 2292 | 1.9% |
| Other values (601) | 59296 |
Length
| Value | Count | Frequency (%) |
| sao | 36362 | 17.9% |
| paulo | 29574 | 14.5% |
| ibitinga | 8373 | 4.1% |
| rio | 5930 | 2.9% |
| do | 5524 | 2.7% |
| preto | 5518 | 2.7% |
| de | 4192 | 2.1% |
| jose | 4085 | 2.0% |
| santo | 3270 | 1.6% |
| andre | 3164 | 1.6% |
| Other values (640) | 97267 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (31) | 266265 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1108993 | |
| Space Separator | 85009 | 7.1% |
| Other Punctuation | 614 | 0.1% |
| Modifier Symbol | 369 | < 0.1% |
| Dash Punctuation | 164 | < 0.1% |
| Close Punctuation | 31 | < 0.1% |
| Open Punctuation | 31 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Nonspacing Mark | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | |
| r | 78220 | 7.1% |
| s | 76216 | 6.9% |
| e | 64170 | 5.8% |
| u | 62907 | 5.7% |
| p | 58419 | 5.3% |
| l | 56917 | 5.1% |
| t | 47317 | 4.3% |
| Other values (14) | 217729 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 347 | |
| / | 141 | |
| . | 76 | 12.4% |
| @ | 38 | 6.2% |
| \ | 6 | 1.0% |
| , | 6 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2 | |
| 2 | 2 | |
| 5 | 2 | |
| 0 | 1 | |
| 8 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 85009 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 369 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 164 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 31 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 31 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1108993 | |
| Common | 86226 | 7.2% |
| Inherited | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | |
| r | 78220 | 7.1% |
| s | 76216 | 6.9% |
| e | 64170 | 5.8% |
| u | 62907 | 5.7% |
| p | 58419 | 5.3% |
| l | 56917 | 5.1% |
| t | 47317 | 4.3% |
| Other values (14) | 217729 |
Common
| Value | Count | Frequency (%) |
| 85009 | ||
| ´ | 369 | 0.4% |
| ' | 347 | 0.4% |
| - | 164 | 0.2% |
| / | 141 | 0.2% |
| . | 76 | 0.1% |
| @ | 38 | < 0.1% |
| ) | 31 | < 0.1% |
| ( | 31 | < 0.1% |
| \ | 6 | < 0.1% |
| Other values (6) | 14 | < 0.1% |
Inherited
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1194850 | |
| None | 369 | < 0.1% |
| Diacriticals | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (29) | 265894 |
None
| Value | Count | Frequency (%) |
| ´ | 369 |
Diacriticals
| Value | Count | Frequency (%) |
| ̃ | 2 |
seller_state
Categorical
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 5036 |
| SC | 4271 |
| Other values (18) | 6216 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 236620 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 84377 | |
| MG | 9314 | 7.8% |
| PR | 9096 | 7.6% |
| RJ | 5036 | 4.2% |
| SC | 4271 | 3.6% |
| RS | 2294 | 1.9% |
| DF | 949 | 0.8% |
| BA | 700 | 0.6% |
| GO | 550 | 0.5% |
| PE | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
| (Missing) | 833 | 0.7% |
Length
| Value | Count | Frequency (%) |
| sp | 84377 | |
| mg | 9314 | 7.9% |
| pr | 9096 | 7.7% |
| rj | 5036 | 4.3% |
| sc | 4271 | 3.6% |
| rs | 2294 | 1.9% |
| df | 949 | 0.8% |
| ba | 700 | 0.6% |
| go | 550 | 0.5% |
| pe | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 236620 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 236620 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 236620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
| length_comment_title | length_comment_message | payment_installments | payment_value | price | freight_value | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | order_status | review_score | payment_type | customer_state | product_category_name_english | seller_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| length_comment_title | 1.000 | 0.312 | 0.010 | 0.043 | 0.017 | 0.045 | 0.029 | 0.005 | -0.010 | -0.032 | 0.002 | -0.016 | 0.021 | 0.082 | 0.029 | 0.016 | 0.038 | 0.023 |
| length_comment_message | 0.312 | 1.000 | 0.048 | 0.083 | 0.029 | 0.036 | -0.010 | -0.009 | 0.037 | 0.010 | 0.024 | 0.016 | 0.044 | 0.216 | 0.009 | 0.025 | 0.027 | 0.013 |
| payment_installments | 0.010 | 0.048 | 1.000 | 0.395 | 0.315 | 0.191 | 0.034 | 0.000 | 0.198 | 0.109 | 0.106 | 0.125 | 0.005 | 0.027 | 0.236 | 0.032 | 0.088 | 0.033 |
| payment_value | 0.043 | 0.083 | 0.395 | 1.000 | 0.789 | 0.423 | 0.167 | -0.008 | 0.449 | 0.229 | 0.305 | 0.232 | 0.015 | 0.028 | 0.018 | 0.029 | 0.136 | 0.036 |
| price | 0.017 | 0.029 | 0.315 | 0.789 | 1.000 | 0.433 | 0.206 | 0.030 | 0.514 | 0.266 | 0.327 | 0.271 | 0.014 | 0.012 | 0.014 | 0.020 | 0.114 | 0.052 |
| freight_value | 0.045 | 0.036 | 0.191 | 0.423 | 0.433 | 1.000 | 0.119 | 0.017 | 0.448 | 0.284 | 0.284 | 0.275 | 0.015 | 0.015 | 0.009 | 0.085 | 0.095 | 0.048 |
| product_description_lenght | 0.029 | -0.010 | 0.034 | 0.167 | 0.206 | 0.119 | 1.000 | 0.152 | 0.096 | -0.014 | 0.135 | -0.070 | 0.016 | 0.015 | 0.021 | 0.026 | 0.212 | 0.112 |
| product_photos_qty | 0.005 | -0.009 | 0.000 | -0.008 | 0.030 | 0.017 | 0.152 | 1.000 | 0.008 | 0.012 | -0.072 | -0.006 | 0.012 | 0.016 | 0.005 | 0.014 | 0.154 | 0.040 |
| product_weight_g | -0.010 | 0.037 | 0.198 | 0.449 | 0.514 | 0.448 | 0.096 | 0.008 | 1.000 | 0.619 | 0.532 | 0.621 | 0.011 | 0.020 | 0.018 | 0.028 | 0.199 | 0.078 |
| product_length_cm | -0.032 | 0.010 | 0.109 | 0.229 | 0.266 | 0.284 | -0.014 | 0.012 | 0.619 | 1.000 | 0.248 | 0.632 | 0.014 | 0.018 | 0.022 | 0.017 | 0.258 | 0.084 |
| product_height_cm | 0.002 | 0.024 | 0.106 | 0.305 | 0.327 | 0.284 | 0.135 | -0.072 | 0.532 | 0.248 | 1.000 | 0.338 | 0.016 | 0.018 | 0.015 | 0.019 | 0.278 | 0.065 |
| product_width_cm | -0.016 | 0.016 | 0.125 | 0.232 | 0.271 | 0.275 | -0.070 | -0.006 | 0.621 | 0.632 | 0.338 | 1.000 | 0.004 | 0.014 | 0.020 | 0.016 | 0.291 | 0.057 |
| order_status | 0.021 | 0.044 | 0.005 | 0.015 | 0.014 | 0.015 | 0.016 | 0.012 | 0.011 | 0.014 | 0.016 | 0.004 | 1.000 | 0.149 | 0.037 | 0.026 | 0.030 | 0.029 |
| review_score | 0.082 | 0.216 | 0.027 | 0.028 | 0.012 | 0.015 | 0.015 | 0.016 | 0.020 | 0.018 | 0.018 | 0.014 | 0.149 | 1.000 | 0.010 | 0.048 | 0.054 | 0.023 |
| payment_type | 0.029 | 0.009 | 0.236 | 0.018 | 0.014 | 0.009 | 0.021 | 0.005 | 0.018 | 0.022 | 0.015 | 0.020 | 0.037 | 0.010 | 1.000 | 0.033 | 0.059 | 0.021 |
| customer_state | 0.016 | 0.025 | 0.032 | 0.029 | 0.020 | 0.085 | 0.026 | 0.014 | 0.028 | 0.017 | 0.019 | 0.016 | 0.026 | 0.048 | 0.033 | 1.000 | 0.037 | 0.053 |
| product_category_name_english | 0.038 | 0.027 | 0.088 | 0.136 | 0.114 | 0.095 | 0.212 | 0.154 | 0.199 | 0.258 | 0.278 | 0.291 | 0.030 | 0.054 | 0.059 | 0.037 | 1.000 | 0.176 |
| seller_state | 0.023 | 0.013 | 0.033 | 0.036 | 0.052 | 0.048 | 0.112 | 0.040 | 0.078 | 0.084 | 0.065 | 0.057 | 0.029 | 0.023 | 0.021 | 0.053 | 0.176 | 1.000 |
| order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | review_score | review_creation_date | review_answer_timestamp | length_comment_title | length_comment_message | payment_type | payment_installments | payment_value | shipping_limit_date | price | freight_value | customer_city | customer_state | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | seller_city | seller_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 4.0 | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 0.0 | 170.0 | credit_card | 1.0 | 18.12 | 2017-10-06 11:07:15 | 29.99 | 8.72 | sao paulo | SP | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 1 | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 4.0 | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 0.0 | 170.0 | voucher | 1.0 | 2.00 | 2017-10-06 11:07:15 | 29.99 | 8.72 | sao paulo | SP | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 2 | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 4.0 | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 0.0 | 170.0 | voucher | 1.0 | 18.59 | 2017-10-06 11:07:15 | 29.99 | 8.72 | sao paulo | SP | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 3 | delivered | 2017-08-15 18:29:31 | 2017-08-15 20:05:16 | 2017-08-17 15:28:33 | 2017-08-18 14:44:43 | 2017-08-28 00:00:00 | 4.0 | 2017-08-19 00:00:00 | 2017-08-20 15:16:36 | 0.0 | 84.0 | credit_card | 3.0 | 37.77 | 2017-08-21 20:05:16 | 29.99 | 7.78 | sao paulo | SP | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 4 | delivered | 2017-08-02 18:24:47 | 2017-08-02 18:43:15 | 2017-08-04 17:35:43 | 2017-08-07 18:30:01 | 2017-08-15 00:00:00 | 5.0 | 2017-08-08 00:00:00 | 2017-08-08 23:26:23 | 0.0 | 60.0 | credit_card | 1.0 | 37.77 | 2017-08-08 18:37:31 | 29.99 | 7.78 | sao paulo | SP | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 5 | delivered | 2017-10-23 23:26:46 | 2017-10-25 02:14:11 | 2017-10-27 16:48:46 | 2017-11-07 18:04:59 | 2017-11-13 00:00:00 | 3.0 | 2017-11-08 00:00:00 | 2017-11-10 19:52:38 | 0.0 | 0.0 | boleto | 1.0 | 44.09 | 2017-10-31 02:14:11 | 29.99 | 14.10 | florianopolis | SC | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | maua | SP |
| 6 | delivered | 2017-08-10 13:35:55 | 2017-08-10 13:50:09 | 2017-08-11 13:52:35 | 2017-08-16 19:03:36 | 2017-08-23 00:00:00 | 5.0 | 2017-08-17 00:00:00 | 2017-08-21 12:43:27 | 0.0 | 41.0 | credit_card | 1.0 | 83.69 | 2017-08-16 13:50:09 | 75.90 | 7.79 | itaquaquecetuba | SP | 398.0 | 3.0 | 238.0 | 20.0 | 10.0 | 15.0 | baby | maua | SP |
| 7 | delivered | 2017-08-15 02:03:01 | 2017-08-15 02:15:13 | 2017-08-16 15:52:29 | 2017-08-25 21:59:26 | 2017-08-28 00:00:00 | 4.0 | 2017-08-26 00:00:00 | 2017-08-28 20:10:38 | 0.0 | 44.0 | credit_card | 2.0 | 83.69 | 2017-08-21 02:15:13 | 75.90 | 7.79 | campinas | SP | 398.0 | 3.0 | 238.0 | 20.0 | 10.0 | 15.0 | baby | maua | SP |
| 8 | delivered | 2017-08-01 16:31:35 | 2017-08-02 02:50:25 | 2017-08-03 14:36:34 | 2017-08-09 19:56:50 | 2017-08-23 00:00:00 | 5.0 | 2017-08-10 00:00:00 | 2017-08-11 21:08:38 | 0.0 | 0.0 | boleto | 1.0 | 90.18 | 2017-08-08 02:50:25 | 75.90 | 14.28 | curitiba | PR | 398.0 | 3.0 | 238.0 | 20.0 | 10.0 | 15.0 | baby | maua | SP |
| 9 | delivered | 2017-08-10 14:04:58 | 2017-08-10 14:23:38 | 2017-08-11 13:52:35 | 2017-08-12 11:56:49 | 2017-08-23 00:00:00 | 2.0 | 2017-08-13 00:00:00 | 2017-08-14 12:24:58 | 0.0 | 84.0 | credit_card | 2.0 | 83.69 | 2017-08-16 14:23:38 | 75.90 | 7.79 | campinas | SP | 398.0 | 3.0 | 238.0 | 20.0 | 10.0 | 15.0 | baby | maua | SP |
| order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | review_score | review_creation_date | review_answer_timestamp | length_comment_title | length_comment_message | payment_type | payment_installments | payment_value | shipping_limit_date | price | freight_value | customer_city | customer_state | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | seller_city | seller_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119133 | canceled | 2018-03-01 11:42:23 | 2018-03-01 12:20:32 | NaN | NaN | 2018-03-20 00:00:00 | 1.0 | 2018-03-22 00:00:00 | 2018-03-26 03:00:14 | 0.0 | 0.0 | credit_card | 2.0 | 102.09 | 2018-03-08 12:20:32 | 79.90 | 22.19 | americana | SP | 87.0 | 1.0 | 3500.0 | 20.0 | 20.0 | 20.0 | furniture_decor | pirassununga | SP |
| 119134 | delivered | 2018-08-10 21:14:35 | 2018-08-10 21:25:22 | 2018-08-13 13:54:00 | 2018-08-21 04:16:31 | 2018-08-30 00:00:00 | 5.0 | 2018-08-21 00:00:00 | 2018-08-21 22:01:55 | 0.0 | 0.0 | credit_card | 2.0 | 134.48 | 2018-08-15 21:25:22 | 44.99 | 22.25 | carai | MG | 645.0 | 2.0 | 600.0 | 30.0 | 20.0 | 20.0 | sports_leisure | paulo lopes | SC |
| 119135 | delivered | 2018-08-10 21:14:35 | 2018-08-10 21:25:22 | 2018-08-13 13:54:00 | 2018-08-21 04:16:31 | 2018-08-30 00:00:00 | 5.0 | 2018-08-21 00:00:00 | 2018-08-21 22:01:55 | 0.0 | 0.0 | credit_card | 2.0 | 134.48 | 2018-08-15 21:25:22 | 44.99 | 22.25 | carai | MG | 645.0 | 2.0 | 600.0 | 30.0 | 20.0 | 20.0 | sports_leisure | paulo lopes | SC |
| 119136 | canceled | 2018-03-13 10:58:09 | 2018-03-14 03:08:35 | NaN | NaN | 2018-03-23 00:00:00 | 5.0 | 2018-03-28 00:00:00 | 2018-03-28 18:11:45 | 0.0 | 0.0 | boleto | 1.0 | 321.34 | 2018-03-20 03:08:35 | 149.00 | 11.67 | taboao da serra | SP | 682.0 | 1.0 | 1700.0 | 30.0 | 5.0 | 30.0 | garden_tools | sao paulo | SP |
| 119137 | canceled | 2018-03-13 10:58:09 | 2018-03-14 03:08:35 | NaN | NaN | 2018-03-23 00:00:00 | 5.0 | 2018-03-28 00:00:00 | 2018-03-28 18:11:45 | 0.0 | 0.0 | boleto | 1.0 | 321.34 | 2018-03-20 03:08:35 | 149.00 | 11.67 | taboao da serra | SP | 682.0 | 1.0 | 1700.0 | 30.0 | 5.0 | 30.0 | garden_tools | sao paulo | SP |
| 119138 | delivered | 2018-07-01 10:23:10 | 2018-07-05 16:17:52 | 2018-07-04 14:34:00 | 2018-07-09 15:06:57 | 2018-07-20 00:00:00 | 5.0 | 2018-07-10 00:00:00 | 2018-07-10 18:32:29 | 0.0 | 0.0 | boleto | 1.0 | 93.13 | 2018-07-10 08:32:33 | 79.00 | 14.13 | ferraz de vasconcelos | SP | 516.0 | 2.0 | 750.0 | 30.0 | 28.0 | 28.0 | construction_tools_lights | porto ferreira | SP |
| 119139 | canceled | 2017-03-11 19:51:36 | 2017-03-11 19:51:36 | NaN | NaN | 2017-03-30 00:00:00 | 1.0 | 2017-04-01 00:00:00 | 2017-04-01 10:24:03 | 0.0 | 0.0 | credit_card | 1.0 | 30.66 | 2017-03-16 19:51:36 | 19.70 | 10.96 | gaspar | SC | 260.0 | 2.0 | 400.0 | 16.0 | 4.0 | 11.0 | auto | blumenau | SC |
| 119140 | delivered | 2018-07-24 09:46:27 | 2018-07-24 11:24:27 | 2018-07-24 15:14:00 | 2018-08-02 22:47:35 | 2018-08-16 00:00:00 | 5.0 | 2018-08-03 00:00:00 | 2018-08-04 11:22:40 | 0.0 | 0.0 | debit_card | 1.0 | 444.07 | 2018-07-30 11:24:27 | 399.00 | 45.07 | fortaleza | CE | 729.0 | 2.0 | 2100.0 | 80.0 | 8.0 | 30.0 | furniture_decor | americana | SP |
| 119141 | delivered | 2018-05-22 21:13:21 | 2018-05-22 21:35:40 | 2018-05-24 12:28:00 | 2018-06-12 23:11:29 | 2018-06-08 00:00:00 | 4.0 | 2018-06-10 00:00:00 | 2018-06-13 09:17:47 | 0.0 | 0.0 | credit_card | 4.0 | 244.02 | 2018-05-28 21:31:24 | 219.90 | 24.12 | teofilo otoni | MG | 531.0 | 1.0 | 5900.0 | 41.0 | 21.0 | 41.0 | furniture_decor | sao paulo | SP |
| 119142 | delivered | 2018-05-15 17:41:00 | 2018-05-16 03:35:29 | 2018-05-16 17:20:00 | 2018-05-21 14:31:41 | 2018-05-29 00:00:00 | 5.0 | 2018-06-01 00:00:00 | 2018-06-01 15:14:23 | 0.0 | 0.0 | boleto | 1.0 | 28.29 | 2018-05-22 03:35:29 | 15.50 | 12.79 | sao bernardo do campo | SP | 871.0 | 1.0 | 83.0 | 17.0 | 8.0 | 13.0 | perfumery | ribeirao preto | SP |
Most frequently occurring
| order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | review_score | review_creation_date | review_answer_timestamp | length_comment_title | length_comment_message | payment_type | payment_installments | payment_value | shipping_limit_date | price | freight_value | customer_city | customer_state | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | seller_city | seller_state | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1698 | delivered | 2017-08-23 09:22:34 | 2017-08-24 14:30:23 | 2017-08-25 20:07:36 | 2017-09-02 12:13:03 | 2017-09-21 00:00:00 | NaN | NaN | NaN | NaN | NaN | credit_card | 4.0 | 2262.80 | 2017-08-30 14:30:23 | 98.70 | 14.44 | goiania | GO | 1042.0 | 1.0 | 1400.0 | 20.0 | 31.0 | 30.0 | auto | sao paulo | SP | 20 |
| 4451 | delivered | 2018-02-22 15:30:41 | 2018-02-24 03:20:27 | 2018-03-02 00:18:01 | 2018-03-05 15:22:27 | 2018-03-08 00:00:00 | 1.0 | 2018-03-06 00:00:00 | 2018-03-12 12:46:07 | 0.0 | 0.0 | boleto | 1.0 | 2202.40 | 2018-03-01 02:50:48 | 100.00 | 10.12 | sao paulo | SP | 452.0 | 1.0 | 360.0 | 19.0 | 18.0 | 15.0 | computers_accessories | sao jose dos campos | SP | 20 |
| 6487 | delivered | 2018-06-12 00:22:18 | 2018-06-12 01:35:10 | 2018-06-13 14:13:00 | 2018-06-14 14:58:59 | 2018-06-21 00:00:00 | 4.0 | 2018-06-15 00:00:00 | 2018-06-15 19:25:55 | 0.0 | 0.0 | voucher | 1.0 | 15.48 | 2018-06-18 01:30:50 | 29.00 | 7.94 | paulinia | SP | 383.0 | 1.0 | 100.0 | 20.0 | 15.0 | 12.0 | sports_leisure | amparo | SP | 18 |
| 1542 | delivered | 2017-08-08 20:26:31 | 2017-08-08 20:43:31 | 2017-08-10 11:58:14 | 2017-08-14 12:46:18 | 2017-08-30 00:00:00 | 5.0 | 2017-08-15 00:00:00 | 2017-08-17 22:17:55 | 0.0 | 0.0 | voucher | 1.0 | 16.70 | 2017-08-14 20:43:31 | 12.99 | 23.21 | sao paulo | SP | 86.0 | 2.0 | 1300.0 | 50.0 | 9.0 | 41.0 | bed_bath_table | tres rios | RJ | 16 |
| 136 | delivered | 2017-01-30 21:44:49 | 2017-01-30 22:33:45 | 2017-02-01 14:34:10 | 2017-02-14 10:48:10 | 2017-03-07 00:00:00 | 5.0 | 2017-02-15 00:00:00 | 2017-02-16 17:14:41 | 0.0 | 0.0 | credit_card | 10.0 | 783.00 | 2017-02-03 21:44:49 | 51.00 | 1.20 | goiania | GO | 369.0 | 2.0 | 600.0 | 38.0 | 16.0 | 25.0 | garden_tools | jaragua do sul | SC | 15 |
| 2851 | delivered | 2017-11-23 20:30:52 | 2017-11-24 10:31:10 | 2017-11-28 16:42:21 | 2017-12-13 20:19:35 | 2017-12-19 00:00:00 | 5.0 | 2017-12-14 00:00:00 | 2017-12-19 14:14:16 | 0.0 | 0.0 | credit_card | 10.0 | 1225.65 | 2017-11-30 10:30:51 | 65.49 | 16.22 | uniao da vitoria | PR | 1744.0 | 2.0 | 700.0 | 62.0 | 15.0 | 15.0 | furniture_decor | fernandopolis | SP | 15 |
| 903 | delivered | 2017-05-29 14:06:33 | 2017-05-29 14:25:14 | 2017-05-30 09:25:02 | 2017-06-01 15:34:09 | 2017-06-09 00:00:00 | 5.0 | 2017-06-02 00:00:00 | 2017-06-03 17:09:01 | 0.0 | 0.0 | voucher | 1.0 | 50.00 | 2017-06-02 14:25:14 | 723.74 | 17.02 | sao paulo | SP | 2396.0 | 2.0 | 3600.0 | 36.0 | 10.0 | 23.0 | musical_instruments | braganca paulista | SP | 14 |
| 1539 | delivered | 2017-08-08 20:26:31 | 2017-08-08 20:43:31 | 2017-08-10 11:58:14 | 2017-08-14 12:46:18 | 2017-08-30 00:00:00 | 5.0 | 2017-08-15 00:00:00 | 2017-08-17 22:17:55 | 0.0 | 0.0 | voucher | 1.0 | 2.61 | 2017-08-14 20:43:31 | 12.99 | 23.21 | sao paulo | SP | 86.0 | 2.0 | 1300.0 | 50.0 | 9.0 | 41.0 | bed_bath_table | tres rios | RJ | 14 |
| 3372 | delivered | 2017-12-13 14:21:15 | 2017-12-15 02:30:41 | 2017-12-15 18:45:18 | 2017-12-28 09:05:34 | 2018-01-08 00:00:00 | 1.0 | 2017-12-29 00:00:00 | 2017-12-31 12:08:24 | 0.0 | 0.0 | boleto | 1.0 | 1014.02 | 2017-12-21 02:30:41 | 59.00 | 13.43 | santos | SP | 348.0 | 2.0 | 1550.0 | 30.0 | 22.0 | 30.0 | garden_tools | sao jose do rio preto | SP | 14 |
| 4412 | delivered | 2018-02-21 11:45:07 | 2018-02-22 11:48:42 | 2018-02-27 18:27:01 | 2018-03-01 20:47:01 | 2018-03-07 00:00:00 | 1.0 | 2018-03-02 00:00:00 | 2018-03-03 00:44:54 | 0.0 | 74.0 | credit_card | 6.0 | 528.78 | 2018-02-28 11:48:12 | 29.99 | 7.78 | indaiatuba | SP | 55.0 | 1.0 | 300.0 | 20.0 | 20.0 | 13.0 | telephony | santo andre | SP | 14 |